Editing SAS Metadata – Automated From CSV Files Using XML String in SAS Data Integration Studio
نویسنده
چکیده
The SAS Metadata Server® introduces a new world to clinical data programmers. It is a storage centre to store information about every single object there is in the SAS System®. Not only the table level and column level attributes such as SAS table labels and column lengths, extended attributes are also built in and extensible to keep valuable business data in this centralized location. To access the metadata, SAS Data Integration Studio® or SAS Management Console® provides a GUI environment. However, they both lack a single interface to manage all the related metadata for a table including the extended attributes.
منابع مشابه
117-2010: The Power of User-Defined SAS® Code in SAS® Data Integration Studio
Extensive use of standard SAS® Data Integration Studio Transformations is often made when designing data warehouses, thereby reducing maintenance requirements and the need for user defined code. This paper instead advocates using the SAS Data Integration Studio API against user defined code. Thus using the full power of SAS to build and maintain warehouse processes may yield several advantages,...
متن کاملXML for Electronic Submission: A Possible Better Alternative to SAS Transport Files
The eXtensible Markup Language (XML) is the next generation of ASCII text file. It was developed to describe, transfer, deliver and share data across different platforms and applications. Its hierarchical data structure allows XML to establish relationships among elements and other inside/outside sources. As the use of XML gains momentum, it may be accepted by the FDA as a data format for elect...
متن کاملReducing Statisticians’ Programming Load: Automated Statistical Analysis with SAS® and XMLTM
Statisticians often spend more time programming and supervising the programming for tables than they spend on the statistical analyses reported in the tables. Features new in versions 7 and 8 of SAS coupled with XML make it possible to reduce this programming load by automating analysis steps. In the automated system, a statistician prepares table shells and database maps with publishing softwa...
متن کاملXML in the DATA Step
SAS Institute’s (SI) XMLMAP imports XML via the LIBNAME XML engine and a mapping file, by-passing the DATAstep. For export of XML, SI offers custom tagsets and the Output Delivery System (ODS). Custom tagsets are built with PROC TEMPLATE, by-passing the DATA-step. By contrast, the DATA-step method discussed in this paper uses a single, uniform methodology to import, export, and transform user-d...
متن کاملConstructing a Data Warehouse for Pharmacokinetic Data
The construction of a warehouse using data from DuPont Pharmaceutical’s Clinical Pharmacokinetics Group with the SAS/Warehouse Administrator product is described herein. Data sources incorporated into the pharmacokinetic warehouse existed in multiple formats (Oracle, Excel, SAS data sets, etc) and were represented by numerous individual files, rather then few large files. In most cases, the da...
متن کامل